package com.sis.constant;


public final class MergeFileConstants {
	
	// file pattern
	public static final  String TXT_TYPE = ".txt";
	public static final  String SPLIT = "\",\"";
	public static final  String PATTERNFILE = "ProductMaster_";
	public static final  String INTERFACEFILE = "ProductMasterDataOnWebOnly"+TXT_TYPE;
	

	// Label
	public static final  String USERCODE = "CUSTOMERCODE";
	public static final  String USERNAME = "CUSTOMERNAME";
	
	public static final  String ATTRIBUTE = "ATTRIBUTE";
	public static final  String VALUE = "VALUE";

	
	public static final  String NAME = "NAME";
	public static final  String SKU  = "SKU";
	public static final  String CUSTOMER_MATERIAL_INFO_APPLY = "CUSTOMER_MATERIAL_INFO_APPLY";
	public static final  String SHORT_DESCRIPTION  = "SHORT_DESCRIPTION";
	public static final  String DESCRIPTION  = "DESCRIPTION";
	public static final  String TYPE_ID  =  "TYPE_ID";
	public static final  String WEIGHT  = "WEIGHT";
	public static final  String STATUS = "STATUS";
	public static final  String TAX_CLASS_ID  = "TAX_CLASS_ID";
	public static final  String URL_KEY  = "URL_KEY";
	public static final  String URL_PATH  =  "URL_PATH";
	public static final  String VISIBILITY = "VISIBILITY";
	public static final  String MANUFACTURER =  "MANUFACTURER";
	public static final  String COLOR = "COLOR";
	public static final  String NEWS_FROM_DATE =  "NEWS_FROM_DATE";
	public static final  String NEWS_TO_DATE  = "NEWS_TO_DATE";
	public static final  String COUNTRY_OF_MANUFACTURE =  "COUNTRY_OF_MANUFACTURE";
	public static final  String PRICE = "PRICE";
	public static final  String GROUP_PRICE = "GROUP_PRICE";
	public static final  String MSRP = "MSRP";
	public static final  String TIER_PRICE = "TIER_PRICE";
	public static final  String COST = "COST";
	public static final  String MIN_PRICE = "MIN_PRICE";
	public static final  String DIMENSION = "DIMENSION";
	public static final  String BY_ORDER =  "BY_ORDER";
	public static final  String PRICE_BARGAIN = "PRICE_BARGAIN";
	public static final  String SPECIAL_PRICE = "SPECIAL_PRICE";
	public static final  String SPECIAL_FROM_DATE = "SPECIAL_FROM_DATE";
	public static final  String SPECIAL_TO_DATE = "SPECIAL_TO_DATE";
	public static final  String ENABLE_GOOGLECHECKOUT = "ENABLE_GOOGLECHECKOUT";
	public static final  String MSRP_ENABLED = "MSRP_ENABLED";
	public static final  String META_TITLE = "META_TITLE";
	public static final  String META_KEYWORD = "META_KEYWORD";
	public static final  String META_DESCRIPTION =  "META_DESCRIPTION";
	public static final  String MEDIA_IMAGE =  "MEDIA_IMAGE";
	public static final  String CUSTOM_DESIGN = "CUSTOM_DESIGN";
	public static final  String CUSTOM_DESIGN_FROM = "CUSTOM_DESIGN_FROM";
	public static final  String CUSTOM_DESIGN_TO = "CUSTOM_DESIGN_TO";
	public static final  String CUSTOM_LAYOUT_UPDATE =  "CUSTOM_LAYOUT_UPDATE";
	public static final  String PAGE_LAYOUT = "PAGE_LAYOUT";
	public static final  String IS_RECURRING = "IS_RECURRING";
	public static final  String RECURRING_PROFILE = "RECURRING_PROFILE";
	public static final  String GIFT_MESSAGE_AVAILABLE = "GIFT_MESSAGE_AVAILABLE";
	public static final  String ATTRIBUTE_SET_NAME = "ATTRIBUTE_SET_NAME";
	public static final  String CATEGORY_IDS = "CATEGORY_IDS";
	public static final  String CREATED_AT = "CREATED_AT";
	public static final  String UPDATED_AT = "UPDATED_AT";
	public static final  String RELATION = "RELATION";
	public static final  String CROSS_SELL = "CROSS_SELL";
	public static final  String UP_SELL = "UP_SELL";
	public static final  String BUNDLE_SHIP = "BUNDLE_SHIP";
	public static final  String BUNDLE_OPTIONS = "BUNDLE_OPTIONS";
	public static final  String BUNDLE_SELECTIONS = "BUNDLE_SELECTIONS";
	public static final  String SPEC_PATH = "SPEC_PATH";
	public static final  String IN_DEPTH = "IN_DEPTH";
	public static final  String BARGAIN_QTY =  "BARGAIN_QTY";
	public static final  String WHT = "WHT";
	public static final  String IS_IN_STOCK = "IS_IN_STOCK";
	public static final  String MANAGE_STOCK = "MANAGE_STOCK";
	public static final  String PRODUCT_COMPANY = "PRODUCT_COMPANY";
	public static final  String FREE_GOODS = "FREE_GOODS";
	public static final  String PRO_FREE_GOODS = "PRO_FREE_GOODS";
	public static final  String PRODUCT_OWNER = "PRODUCT_OWNER";
	
	public static final  String BEST_PRODUCT = "BEST_PRODUCT";
	public static final  String BEST_RANKING = "BEST_RANKING";
	public static final  String NEW_PRODUCT = "NEW_PRODUCT";
	public static final  String NEW_RANKING = "NEW_RANKING";
	public static final  String SPECIAL_PRODUCT = "SPECIAL_PRODUCT";
	public static final  String SPECIAL_RANKING = "SPECIAL_RANKING";

	
	// SQL Command
	public static final  String FINDUDER = "select distinct u.cust_code as "+USERCODE+", u.username as " +USERNAME+
			" from productentity p, userlogin u where p.created_by = u.username";
	
	public static final String FINDPRODUCTENTITYSOMECOLUMN = "select price as "+PRICE+" ,msrp as "+MSRP+" ,min_price as "+MIN_PRICE+"  from productentity where sku = ? and created_by = ? ";
	
	public static final String FINDPRODUCTENTITYALLCOLUMN =  "select name "+
			",sku as "+SKU+
			",customer_material_info_apply as "+CUSTOMER_MATERIAL_INFO_APPLY+
			",short_description as "+SHORT_DESCRIPTION+
			",description as "+DESCRIPTION+
			",type_id as "+TYPE_ID+
			",weight as "+WEIGHT+
			",status as "+STATUS+
			",tax_class_id as "+TAX_CLASS_ID+
			",url_key as "+URL_KEY+
			",url_path as "+URL_PATH+
			",visibility as "+VISIBILITY+
			",manufacturer as "+MANUFACTURER+
			",color as "+COLOR+
			",news_from_date as "+NEWS_FROM_DATE+
			",news_to_date as "+NEWS_TO_DATE+
			",country_of_manufacture as "+COUNTRY_OF_MANUFACTURE+
			",price as "+PRICE+
			",group_price as "+GROUP_PRICE+
			",msrp as "+MSRP+
			",tier_price as "+TIER_PRICE+
			",cost as "+COST+
			",min_price as "+MIN_PRICE+
			",dimension as "+DIMENSION+
			",by_order as "+BY_ORDER+
			",price_bargain as "+PRICE_BARGAIN+
			",special_price as "+SPECIAL_PRICE+
			",special_from_date as "+SPECIAL_FROM_DATE+
			",special_to_date as "+SPECIAL_TO_DATE+
			",enable_googlecheckout as "+ENABLE_GOOGLECHECKOUT+
			",msrp_enabled as "+MSRP_ENABLED+
			",meta_title as "+META_TITLE+
			",meta_keyword as "+META_KEYWORD+
			",meta_description as "+META_DESCRIPTION+
			",media_image as "+MEDIA_IMAGE+
			",custom_design as "+CUSTOM_DESIGN+
			",custom_design_from as "+CUSTOM_DESIGN_FROM+
			",custom_design_to as "+CUSTOM_DESIGN_TO+
			",custom_layout_update as "+CUSTOM_LAYOUT_UPDATE+
			",page_layout as "+PAGE_LAYOUT+
			",is_recurring as "+IS_RECURRING+
			",recurring_profile as "+RECURRING_PROFILE+
			",gift_message_available as "+GIFT_MESSAGE_AVAILABLE+
			",attribute_set_name as "+ATTRIBUTE_SET_NAME+
			",category_ids as "+CATEGORY_IDS+
			",created_at as "+CREATED_AT+
			",updated_at as "+UPDATED_AT+
			",relation as "+RELATION+
			",cross_sell as "+CROSS_SELL+
			",up_sell as "+UP_SELL+
			",bundle_ship as "+BUNDLE_SHIP+
			",bundle_options as "+BUNDLE_OPTIONS+
			",bundle_selections as "+BUNDLE_SELECTIONS+
			",spec_path as "+SPEC_PATH+
			",in_depth as "+IN_DEPTH+
			",bargain_qty as "+BARGAIN_QTY+
			",wht as "+WHT+
			",is_in_stock as "+IS_IN_STOCK+
			",manage_stock as "+MANAGE_STOCK+
			",product_company as "+PRODUCT_COMPANY+
			",free_goods as "+FREE_GOODS+
			",pro_free_goods as "+PRO_FREE_GOODS+
			",product_owner as "+PRODUCT_OWNER+
			",best_product as "+"BEST_PRODUCT"+
			",best_ranking as "+"BEST_RANKING"+
			",new_product as "+"NEW_PRODUCT"+
	        ",new_ranking as "+"NEW_RANKING"+
	        ",special_product as "+"SPECIAL_PRODUCT"+
	        ",special_ranking as "+"SPECIAL_RANKING"+	
			" from productentity where created_by = ? and sku  not in (select sku from interface) ";
	
	public static final String INSERTINTERFACE = "insert into interface (interface.sku) values ";
	
	public static final String DELETEINTERFACE = "delete from interface";
	
	public static final String FINDPRODUCTSPEC = "select attribute_code as  "+ATTRIBUTE+", value as "+VALUE+" from productspecification where sku = ? and created_by = ? ";

}
